Prerequisites
Before you can use Amazon Redshift as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:
Driver
-
Install and configure the latest Amazon Redshift 64-bit ODBC Driver.
-
Install the Amazon Redshift JDBC Driver on the Compose machine. Amazon are working to resolve a known issue with their latest driver. Until the issue is resolved, JDBC driver 4.1 needs to be used instead.
-
Download the JAR file from:
https://mvnrepository.com/artifact/com.amazon.redshift/redshift-jdbc41/1.2.10.1009
-
Copy it to:
<Compose_Installation_Folder>\java\jdbc
-
The Qlik Compose service needs to be restarted after copying the driver.
Amazon Redshift Cluster
If you haven't already done so, set up an Amazon Redshift cluster and make sure that following information about your Amazon Redshift Cluster is readily available:
- Amazon Redshift Cluster Name
- Amazon Redshift Cluster Port
- Amazon Redshift User Name and Password
- Amazon Redshift Database Name
Permissions
Qlik Replicate performs the following operations on the replicated tables within Amazon Redshift:
- SELECT, INSERT, UPDATE and DELETE
- Bulk Load
- CREATE, ALTER, DROP
- CREATE VIEW
If the user is the 'DB Owner', these permissions are in place by default. Otherwise, the user must be granted these permissions to achieve successful replication.
Port
Make sure that port 5439 (the Amazon Redshift Cluster port) is open for inbound connections from Qlik Compose .